Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
SID | NUMBER(38) | No | null | 1 | null | NO | NO | NO |
PARTIC_OBJ | VARCHAR2(20) | Yes | null | 2 | null | NO | NO | NO |
PARTICIPANT_DISPLAY | VARCHAR2(20) | Yes | null | 3 | null | NO | NO | NO |
FILE_CONTEXT | VARCHAR2(400) | Yes | null | 4 | null | NO | NO | NO |
OWNING_UNIT | VARCHAR2(400) | Yes | null | 5 | null | NO | NO | NO |
LEAD_DISPLAY | VARCHAR2(400) | Yes | null | 6 | null | NO | NO | NO |
OUTCOME | VARCHAR2(4000) | Yes | null | 7 | null | NO | NO | NO |
OUTCOME_SUBCATEGORY | VARCHAR2(4000) | Yes | null | 8 | null | NO | NO | NO |
OFFICE | VARCHAR2(4000) | Yes | null | 9 | null | NO | NO | NO |
START_DATE | DATE | Yes | null | 10 | null | NO | NO | NO |
END_DATE | DATE | Yes | null | 11 | null | NO | NO | NO |
EMPLOYEE_TYPE | VARCHAR2(4000) | Yes | null | 12 | null | NO | NO | NO |
CREATED_BY | VARCHAR2(100) | Yes | null | 13 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CUBE_PARTIC_OUTCOMES_INTERCOMS | VIEW | QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_ACM_REFERENCE | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_PARTIC_INDIV_OFFICE | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_PARTIC_INDIV_OFFICE_REF | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_PARTIC_INV_SUBJ_OUTCOME | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_PARTIC_INVOLVEMENT_REF | TABLE |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | V_CURR_OBJ_STAKEHOLDERS | VIEW |
QART | V_CUBE_INDIV_PARTIC_OUTCOMES | VIEW | QART | MV_PARTIC_INVOLVEMENT | TABLE |
NAME | VALUE |
---|---|
CREATED | 05-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_CUBE_INDIV_PARTIC_OUTCOMES |
TEXT_LENGTH | 1532 |
TEXT | select distinct so.sid, nvl (so.participant, i.participant) as partic_obj, o1.sid as participant_display, O2.TAGLINE FILE_CONTEXT, v1.SH_DISPLAY OWNING_UNIT, v2.SH_DISPLAY LEAD_DISPLAY, nvl (ir2.display, ir1.display) as outcome, case when ir1.parent_row is not null then ir1.display else null end as outcome_subcategory, ior.display as office, io.start_date start_date, io.end_date end_date, r.display as employee_type, so.created_by from mv_partic_inv_subj_outcome so left join mv_partic_involvement i on so.involvement = i.sid left join mv_acm_obj o1 on so.participant = o1.sid or i.participant = o1.sid LEFT JOIN MV_ACM_OBJ O2 ON I.OBJ = O2.SID left join v_curr_obj_stakeholders v1 on i.obj = v1.obj and v1.code = 'OWNING_UNIT' left join v_curr_obj_stakeholders v2 on i.obj = v2.obj and v2.code = 'LEAD' left join mv_partic_indiv_office io on i.indiv_office = io.sid or so.office_assignment = io.sid left join mv_partic_indiv_office_ref ior on io.office = ior.ref_key left join mv_acm_reference r on io.employee_type = r.ref_key left join mv_partic_involvement_ref ir1 on so.outcome = ir1.ref_key left join mv_partic_involvement_ref ir2 on ir1.parent_row = ir2.ref_key |
TEXT_VC | select distinct so.sid, nvl (so.participant, i.participant) as partic_obj, o1.sid as participant_display, O2.TAGLINE FILE_CONTEXT, v1.SH_DISPLAY OWNING_UNIT, v2.SH_DISPLAY LEAD_DISPLAY, nvl (ir2.display, ir1.display) as outcome, case when ir1.parent_row is not null then ir1.display else null end as outcome_subcategory, ior.display as office, io.start_date start_date, io.end_date end_date, r.display as employee_type, so.created_by from mv_partic_inv_subj_outcome so left join mv_partic_involvement i on so.involvement = i.sid left join mv_acm_obj o1 on so.participant = o1.sid or i.participant = o1.sid LEFT JOIN MV_ACM_OBJ O2 ON I.OBJ = O2.SID left join v_curr_obj_stakeholders v1 on i.obj = v1.obj and v1.code = 'OWNING_UNIT' left join v_curr_obj_stakeholders v2 on i.obj = v2.obj and v2.code = 'LEAD' left join mv_partic_indiv_office io on i.indiv_office = io.sid or so.office_assignment = io.sid left join mv_partic_indiv_office_ref ior on io.office = ior.ref_key left join mv_acm_reference r on io.employee_type = r.ref_key left join mv_partic_involvement_ref ir1 on so.outcome = ir1.ref_key left join mv_partic_involvement_ref ir2 on ir1.parent_row = ir2.ref_key |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|